TR
11111

COURSE INTRODUCTION AND APPLICATION INFORMATION

dm.ieu.edu.tr

Course Name
Code
Semester
Theory
(hour/week)
Application/Lab
(hour/week)
Local Credits
ECTS
Fall/Spring
Prerequisites
None
Course Language
Course Type
Elective
Course Level
-
Mode of Delivery -
Teaching Methods and Techniques of the Course Problem Solving
Application: Experiment / Laboratory / Workshop
Course Coordinator -
Course Lecturer(s) -
Assistant(s) -
Course Objectives
Learning Outcomes The students who succeeded in this course;
  • Identify and define the information that is needed to design a database schema for a database application,
  • Create conceptual and physical database designs for a management information system by drawing the E/RDiagram and performing the normalization of relations,
  • Understand the core terms, concepts, and tools of relational database management systems,
  • Query a database using SQL,
  • Implement database applications by properly managing concurrent transactions,
  • Finetune a database design to improve the performance of applications by the use of beneficial indexes and additional data structures conforming to the characteristics of applications running on them.
Course Description

 



Course Category

 Core Courses
Major Area Courses
Supportive Courses
X
Media and Managment Skills Courses
Transferable Skill Courses

 

WEEKLY SUBJECTS AND RELATED PREPARATION STUDIES

Week Subjects Required Materials
1 Introduction to Database Systems, Relational Data Model, SemistructuredData Model J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 1, Ch. 2.1, 2.2, 2.3, Ch. 11.1, 11.2, 11.3)
2 EntityRelationship Data Model J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 4.1, 4.2, 4.3, 4.4, 4.5, 4.6)
3 Introduction to Relational Algebra and Design of Relational Databases, Functional Dependencies J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 2.4, 3.1, 3.2, 3.3, 3.4, 3.5)
4 Design of Relational Databases, Multivalued Dependencies J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 3.6, 3.7)
5 Relational Algebra J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 5.1)
6 Introduction to SQL (Part I) J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 6.1, 6.2, 6.3, 6.4.1, 6.4.2)
7 Introduction to SQL (Part II) J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 5.2, 6.4, 6.5)
8 Midterm
9 Constraints and Triggers J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 7)
10 SQL Programming: Embedded SQL, PSM ( PL/SQL) J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 9.3, 9.4)
11 SQL Programming: CLI, JDBC, PHP/PEAR J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 9.1, 9.2, 9.5, 9.6, 9.7)
12 Transactions, Views, Indexes J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 6.6, 8.1, 8.2, 8.3, 8.4, 8.5)
13 SQL Authorization J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 10.1)
14 Logical Query Languages (Datalog) and SQL Recursion J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 5.3, 5.4, 10.2)
15 Warehousing, Data Cubes, Data Mining J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 10.6, 10.7)
16 Review of the Semester  
Course Notes/Textbooks Textbook "J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008" and course slides (Book’s URL: http://wwwdb.stanford.edu/~ullman/fcdb.html)
Suggested Readings/Materials Reference Book: Silberschatz et. al., Database System Concepts, 4th ed., McGrawHill, 2002.

 

EVALUATION SYSTEM

Semester Activities Number Weigthing
Participation
1
10
Laboratory / Application
7
15
Field Work
Quizzes / Studio Critiques
5
15
Portfolio
Homework / Assignments
15
0
Presentation / Jury
Project
Seminar / Workshop
Oral Exam
Midterm
1
25
Final Exam
1
35
Total

Weighting of Semester Activities on the Final Grade
65
Weighting of End-of-Semester Activities on the Final Grade
35
Total

ECTS / WORKLOAD TABLE

Semester Activities Number Duration (Hours) Workload
Course Hours
(Including exam week: 16 x total hours)
16
3
48
Laboratory / Application Hours
(Including exam week: 16 x total hours)
16
2
Study Hours Out of Class
15
3
Field Work
Quizzes / Studio Critiques
4
2
Portfolio
Homework / Assignments
15
2
Presentation / Jury
Project
Seminar / Workshop
Oral Exam
Midterms
1
17
Final Exams
1
20
    Total
200

 

COURSE LEARNING OUTCOMES AND PROGRAM QUALIFICATIONS RELATIONSHIP

#
 Program Competencies/Outcomes
* Contribution Level
1
2
3
4
5
1 To have a grasp of basic mathematics, applied mathematics and theories and applications of statistics.
2 To be able to use theoretical and applied knowledge acquired in the advanced fields of mathematics and statistics,
3 To be able to define and analyze problems and to find solutions based on scientific methods,
4 To be able to apply mathematics and statistics in real life with interdisciplinary approach and to discover their potentials, X
5 To be able to acquire necessary information and to make modeling in any field that mathematics is used and to improve herself/himself, X
6 To be able to criticize and renew her/his own models and solutions,
7 To be able to tell theoretical and technical information easily to both experts in detail and nonexperts in basic and comprehensible way,
8

To be able to use international resources in English and in a second foreign language from the European Language Portfolio (at the level of B1) effectively and to keep knowledge up-to-date, to communicate comfortably with colleagues from Turkey and other countries, to follow periodic literature,
9

To be familiar with computer programs used in the fields of mathematics and statistics and to be able to use at least one of them effectively at the European Computer Driving Licence Advanced Level,

 X
10

To be able to behave in accordance with social, scientific and ethical values in each step of the projects involved and to be able to introduce and apply projects in terms of civic engagement,
11 To be able to evaluate all processes effectively and to have enough awareness about quality management by being conscious and having intellectual background in the universal sense,
12

By having a way of abstract thinking, to be able to connect concrete events and to transfer solutions, to be able to design experiments, collect data, and analyze results by scientific methods and to interfere,
13

To be able to continue lifelong learning by renewing the knowledge, the abilities and the compentencies which have been developed during the program, and being conscious about lifelong learning,
14

To be able to adapt and transfer the knowledge gained in the areas of mathematics and statistics to the level of secondary school,
15

To be able to conduct a research either as an individual or as a team member, and to be effective in each related step of the project, to take role in the decision process, to plan and manage the project by using time effectively.

*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest

 

İzmir Ekonomi Üniversitesi | Sakarya Caddesi No:156, 35330 Balçova - İZMİR Tel: +90 232 279 25 25 | webmaster@ieu.edu.tr | YBS 2010